Write Cell

Excel.WriteCell(objExcelWorkBook,sheet,strCell,data,bSave)

Write data to the specified cell in the sheet (supports writing formulas)

Required Parameter: objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel)); sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0); strCell--The specified cell, supports two forms: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). When using cell names, it is case insensitive; data--The data to be written, supports writing formulas; bSave--Save immediately after an operation

results matching ""